<?php require_once('../../../Connections/ocmanmanager.php'); 
     require_once('../../../Connections/checkuser.php'); ?>
<?php


mysql_select_db($database_ocmanmanager, $ocmanmanager);
$query_projects = "SELECT * FROM projects ORDER BY projectname ASC";
$projects = mysql_query($query_projects, $ocmanmanager) or die(mysql_error());
$row_projects = mysql_fetch_assoc($projects);
$totalRows_projects = mysql_num_rows($projects);
?>
<!DOCTYPE html> 
<html>
<head>
<meta charset="utf-8">
<title>Ozcrete Mobile - Projects</title>
<meta name="viewport" content="width=device-width, initial-scale=1" /> 
	<link rel="stylesheet" href="http://code.jquery.com/mobile/1.1.1/jquery.mobile-1.1.1.min.css" />
	<script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
	<script src="http://code.jquery.com/mobile/1.1.1/jquery.mobile-1.1.1.min.js"></script>
</head> 
<body> 

<div id="page" data-role="page" data-theme="b">
	<div data-role="header">
		<h1>Projects List</h1>
	</div>
    <div class="ui-grid-a">
			<div class="ui-block-a" style="width:30%;">
			  <ul data-role="listview" data-split-icon="arrow-r" data-theme="c">
			    <li><a href="index.php">Projects</a></li>
			    <li><a href="issues.php">Issues</a></li>
			    <li><a href="orders.php">Orders</a></li>
		      </ul>
</div>
			<div class="ui-block-b" style="width:70%;"><div data-role="content">	
		<ul data-role="listview" data-split-icon="arrow-r" data-theme="c" data-filter="true">
			<?php do { ?>
			  <li><a href="project.php?id=<?php echo $row_projects['id']; ?>" data-transition="slide"><?php echo ucfirst($row_projects['projectname']); ?></a></li>
			  
              <?php } while ($row_projects = mysql_fetch_assoc($projects)); ?>
		</ul>		
	</div></div>
		</div><!-- /grid-a -->
        
	
	<div data-role="footer">
		<h4>Ozcrete Pools</h4>
	</div>
</div>



</body>
</html>
<?php
mysql_free_result($projects);
?>
